{\rtf1\ansi\deff1\adeflang1025
{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fprq2\fcharset0 Times New Roman;}{\f2\fswiss\fprq2\fcharset0 Arial;}{\f3\froman\fprq2\fcharset0 Times New Roman;}{\f4\froman\fprq2\fcharset128 Times New Roman;}{\f5\fswiss\fprq2\fcharset0 DejaVu Sans;}{\f6\fnil\fprq2\fcharset0 DejaVu Sans;}}
{\colortbl;\red0\green0\blue0;\red128\green128\blue128;}
{\stylesheet{\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081\snext1 Normal;}
{\s2\sb240\sa120\keepn\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\rtlch\af6\afs28\lang255\ltrch\dbch\af6\langfe255\hich\f2\fs28\lang3081\loch\f2\fs28\lang3081\sbasedon1\snext3 Heading;}
{\s3\sa120\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081\sbasedon1\snext3 Body Text;}
{\s4\sa120\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081\sbasedon3\snext4 List;}
{\s5\sb120\sa120\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\rtlch\af1\afs24\lang255\ai\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\i\loch\f1\fs24\lang3081\i\sbasedon1\snext5 caption;}
{\s6\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081\sbasedon1\snext6 Index;}
}
{\info{\creatim\yr0\mo0\dy0\hr0\min0}{\revtim\yr0\mo0\dy0\hr0\min0}{\printim\yr0\mo0\dy0\hr0\min0}{\comment StarWriter}{\vern6800}}\deftab709
{\*\pgdsctbl
{\pgdsc0\pgdscuse195\pgwsxn12240\pghsxn15840\marglsxn1800\margrsxn1800\margtsxn1440\margbsxn1440\pgdscnxt0 Standard;}}
{\*\pgdscno0}\paperh15840\paperw12240\margl1800\margr1800\margt1440\margb1440\sectd\sbknone\pgwsxn12240\pghsxn15840\marglsxn1800\margrsxn1800\margtsxn1440\margbsxn1440\ftnbj\ftnstart1\ftnrstcont\ftnnar\aenddoc\aftnrstcont\aftnstart1\aftnnrlc
\pard\plain \ltrpar\s1\cf0\qc{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sb240\sa120\keepn\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\fs28\b\loch\fs28\b DBMS}}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\f4\fs28\b\loch\f4\fs28\b   Spike Plan}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\b\loch\b Name:}}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch  DBMS Spike Plan}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ab\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\b\loch\f1\fs24\lang3081\b {\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b Overview: }
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081 {\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0 Create scripts and/or processes that will create a JavaDB database, the schema and then  populate with some data}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ab\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\b\loch\f1\fs24\lang3081\b {\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b Background/Context: }
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081 {\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0 The purpose of this spike is to determine what is required for creating a JavaDB database and initialising it with the required schema and then populating it with the required data.}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ab\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\b\loch\f1\fs24\lang3081\b {\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b Goals: }
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\li720\ri0\lin720\rin0\fi-360\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\f5\loch\f5 1.\tab }}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch Produce a DBMS create script that will create a JavaDB instance}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\li720\ri0\lin720\rin0\fi-360\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\f5\loch\f5 2.\tab }}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch Create SQL Scripts that will define the DB tables and schema}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\li720\ri0\lin720\rin0\fi-360\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\f5\loch\f5 3.\tab }}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch Populate the DB with some data}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\li720\ri0\lin720\rin0\fi-360\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\f5\loch\f5 4.\tab }}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch Create a script that will remove the JavaDB when required}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ab\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\b\loch\f1\fs24\lang3081\b {\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b Risk:}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\li720\ri0\lin720\rin0\fi-360\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\f5\loch\f5 1.\tab }}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch The team is not familiar with JavaDB and Apache Derby}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\li720\ri0\lin720\rin0\fi-360\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081 {\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0 2.  Potential problems setting up the JavaDB environment }
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ab\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\b\loch\f1\fs24\lang3081\b {\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b Deliverables: }
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\li720\ri0\lin720\rin0\fi-360\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\f5\loch\f5 1.\tab }}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch A Set of script files that will successfully create an instance of a JavaDB}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\li720\ri0\lin720\rin0\fi-360\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\f5\loch\f5 2.\tab }}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch A set of SQL Script files that will create the schema for the database}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\li720\ri0\lin720\rin0\fi-360\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\f5\loch\f5 3.\tab }}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch Script files that will populate the database}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\li720\ri0\lin720\rin0\fi-360\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081 {\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0 4.  Script files that will clean-up and remove the database}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\b\loch\b Resources:}}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch  James Owen}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\b\loch\b Deadline:}}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch  24 April 2008}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ab\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\b\loch\f1\fs24\lang3081\b {\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b Design Notes: }
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\li720\ri0\lin720\rin0\fi-360\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\f5\loch\f5 1.\tab }}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch DB Model defined in Google Docs - Previously submitted for Assignment 6}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\li720\ri0\lin720\rin0\fi-360\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081 {\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0 http://docs.google.com/Doc?docid=dffsx5bp_1dtf7qhcw&hl=en_GB}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\li720\ri0\lin720\rin0\fi-360\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081 
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ab\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\b\loch\f1\fs24\lang3081\b {\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b Current Status:}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\b\loch\b 10/04/2008}}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch  \'96 DB Model and Design has been Produced}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\b\loch\b 19/04/2008}}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch  \'96 DB table and object scripts created}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\b\loch\b 20/04/2008}}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch  \'96 Attempt to create ANT project for building DB}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\b\loch\b 21/04/2008}}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch  \'96 Attempting to load data into DB - difficulties cause by CLOB data types and auto generated ID's}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\b\loch\b 22/04/2008}}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch  \'96 Write small Java App to populate subject data from XML}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\rtlch\ltrch\dbch\hich\b\loch\b 23/04/2008}}{\rtlch \ltrch\loch\f1\fs24\lang3081\i0\b0{\ltrch\dbch  \'96 Write Batch files and scripts to populate and teardown db}}
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081 
\par \pard\plain \ltrpar\s1\cf0{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}\sa120\rtlch\af1\afs24\lang255\ltrch\dbch\af1\langfe255\hich\f1\fs24\lang3081\loch\f1\fs24\lang3081 
\par }